You are here: Reference Guide > Table Structure

Table Structure

Lists documentation on table structures and relationships between the tables for the various modules.

Copyright © 2012 Jiwa Financials. All rights reserved.

Archiving

AR_ArchiveRepositories

AR_History

AR_Libary

AR_Main

AR_Profiler

AR_Provider

AR_ProviderFilters

AR_ProviderHeaders

AR_Schedules

AR_TaskFilters

AR_TaskHistory

AR_Tasks

Automatic Postings

Application Ledger Accounts

Application Scenario

Creditor Transactions

Creditors

Debtor Transactions

Debtors

Goods & Services Tax (GST / VAT)

Impact on the Purchasing Cycle

Inventory

Ledger Groups

Ledger Report Codes

No Cost of Goods Ledger

Purchase Invoice

Purchase Invoice

Purchase Invoice

Purchase Invoice

Purchase Order

Purchase Orders

Receival Slip

Receival Slip

Receival Slip

Receiving Slips

Sales Orders

Sales Tax

Standard Costing - Break Down Variance FX Applicable

Standard Costing - No Variance Breakdown

Standard Costing - Variance Breakdown

Stock Transfers & Adjustments

Wholesale Tax

Bill of Materials

BO_BuildBillDetails

BO_BuildBillDetailsHS

BO_BuildLineDetails

BO_BuildLineDetailsHS

BO_BuildLines

BO_BuildLinesHS

BO_BuildList

BO_BuildListDetails

BO_BuildMain

BO_BuildMainHS

BO_BuildUsageDetails

BO_CustomSetting

BO_CustomSettingValues

BO_Documents

BO_Journals

BO_LineColors

BO_Lines

BO_LinesHS

BO_Main

BO_MainHS

BO_Notes

BO_OnBackOrder

BO_Options

BO_ReservedStock

BO_SOH

BO_WarehouseSOH

Cash Book

Bank Reconciliation

BR_BankTransOLD

BR_CBTransAllocsOLD

BR_CBTransOLD

BR_CustomSetting

BR_CustomSettingValues

BR_DirectCreditorPaymentAllocations

BR_DirectCreditorPayments

BR_DirectCreditorReceipts

BR_DirectDebtorPayments

BR_DirectDebtorReceiptAllocations

BR_DirectDebtorReceipts

BR_DirectGLTransactions

BR_Documents

BR_DocumentTypes

BR_GLTransactions

BR_CBTrans

BR_JBRelationship

BR_Transactions

BR_OpeningBalanceTransactions

BR_MainOLD

BR_Main

CashBook Receipts and Payments

CB_BatchTranLines

CB_BatchTranLinesAllocs

CB_BatchTrans

CB_CustomSetting

CB_CustomSettingValues

CB_Documents

CB_Notes

Contacts

CN_Contact

CN_ContactPosition

CN_Documents

CN_Group

CN_GroupLink

CN_Main

CN_Notes

CN_SyncLog

Creditors

CR_AllocationBatch

CR_AllocationBatchTransactions

CR_AutoTran

CR_AutoTransLines

CR_BatchPayLines

CR_BatchPayment

CR_BatchTranLines

CR_BatchTrans

CR_Classification

CR_CustomSetting

CR_CustomSettingValues

CR_Documents

CR_ForwardCover

CR_ForwardCoverNotes

CR_ForwardCoverTransactions

CR_Main

CR_Notes

CR_Purchases

CR_Trans

CR_TransAlloc

CR_Warehouse

Debtors

DB_AutoTran

DB_AutoTranLines

DB_BatchTranLines

DB_BatchTrans

DB_Budget

DB_Category1

DB_Category2

DB_Category3

DB_Category4

DB_Category5

DB_Classification

DB_CreditNotes

DB_CustomSetting

DB_CustomSettingValues

DB_DebtorSystemFieldValues

DB_DebtorSystems

DB_DebtorSystemTemplateFields

DB_DebtorSystemTemplates

DB_DeliveryAddress

DB_Directors

DB_Documents

DB_EDIMain

DB_FreightForwardAddress

DB_Main

DB_Notes

DB_PricingGroups

DB_Trans

DB_TransAlloc

DB_TransNotes

Foreign Currency

FX_Currency

FX_CurrencyRates

General Ledger

GL_AutoJournalLines

GL_AutoJournals

GL_BankDetails

GL_Budget1

GL_Budget2

GL_Budget3

GL_Category

GL_Config

GL_Distribution

GL_Ledger

GL_Movement

GL_Segment

GL_Sets

GL_TranAllocs

GL_TranCodes

GL_Transactions

Human Resources

HR_CustomSetting

HR_CustomSettingValues

HR_Documents

HR_Messages

HR_Notes

HR_RolePermissions

HR_Roles

HR_SessionHistory

HR_SessionLogBan

HR_Staff

HR_StaffAccess

HR_StaffRoles

Import Queue

EX_ExportPending

EX_ExportQueue

IM_CSV_Staging

Inventory

IN_Alternate

IN_Assembly

IN_AssemblyHistory

IN_AssemblyLineDetails

IN_AssemblyLines

IN_BackOrderAlloc

IN_BackOrderAllocLines

IN_BinLocation

IN_BinLocationCustomFields

IN_BinLocationCustomValues

IN_BinLocationLookup

IN_Budget

IN_Category1

IN_Category2

IN_Category3

IN_Category4

IN_Category5

IN_Classification

IN_CollectionOfGroups

IN_Colours

IN_Components

IN_CostChange

IN_CostChangeLines

IN_Creditor

IN_CreditorCustomFields

IN_CreditorCustomValues

IN_CustomSetting

IN_CustomSettingValues

IN_DebtorPartNumbers

IN_Description

IN_Documents

IN_Duty

IN_Freight

IN_Group

IN_GroupLink

IN_InTransitWH

IN_KitStockTakeLineKitComponents

IN_KitStockTakeLineKits

IN_Logical

IN_LogicalOrder

IN_Main

IN_Notes

IN_OnBackOrder

IN_OrderLevels

IN_Physical

IN_POS

IN_Price

IN_PriceLink

IN_PriceSchemePrice

IN_PriceSchemePriority

IN_PriceSchemes

IN_PricingGroupMatrix

IN_PricingGroups

IN_ProductAvailability

IN_Region

IN_RegionSupplierOrdering

IN_SellingPrices

IN_Sizes

IN_SOH

IN_SOHAudit

IN_SpecificPrice

IN_StandCost

IN_StandCostLine

IN_StockTakeLineDetails

IN_StockTakeLines

IN_StockTakeMain

IN_StyleColourSizeMatrix

IN_Styles

IN_SupplierWarehouse

IN_SupplierWarehouseCustomFields

IN_SupplierWarehouseCustomValues

IN_Transfer

IN_TransferCustomSetting

IN_TransferCustomSettingValues

IN_TransferDocuments

IN_TransferLines

IN_TransferNotes

IN_TransferReasons

IN_UpSell

IN_WarehouseSOH

WH_TranferLineDetails

WH_Transfer

WH_TransferLines

Job Costing

JB_Budget

JB_Classification

JB_CostCentre

JB_CostEntry

JB_CostEntryLines

JB_CostLineDetails

JB_Documents

JB_ExpectedGoods

JB_Main

JB_Notes

JB_PaymentDetails

JB_Resources

JB_Setup

JB_Staffs

JB_Stages

Landed Cost

SH_ApportionedCostsAmounts

SH_ApportionedCostsOnPO

SH_BookInDetailLines

SH_BookInDetailLinesCostAudit

SH_BookInLines

SH_BookInMain

SH_Costs

SH_CostTypes

SH_Invoices

SH_Lines

SH_Main

SH_PurchaseOrders

SH_Voti

Purchase Order

PO_BatchHeader

PO_BatchPurchaseOrderLines

PO_BatchPurchaseOrders

PO_Classification

PO_CustomSettings

PO_CustomSettingValues

PO_Documents

PO_EmailLog

PO_Lines

PO_Main

PO_Notes

PO_ReorderMethods

PO_ShippingAddress

PO_WorkflowLines

PO_Workflows

Purchase Invoice

PI_Lines

PI_LinesDetails

PI_Main

PI_Receipts

Receipts

RE_Lines

RE_Main

RE_OrdersUsed

Quotation

QO_ActivateBatch

QO_ActivateBatchLines

QO_CashSale

QO_CustomSetting

QO_CustomSettingValues

QO_Documents

QO_EmailLog

QO_History

QO_HistoryActivate

QO_LineCustomFields

QO_LineCustomValues

QO_LineExtra

QO_Lines

QO_Main

QO_Notes

QO_OpportunityStatusReasons

QO_SalesStages

QO_SOLink

Sales Orders

BO_ManualReleaseBatch

BO_ManualReleaseBatchLines

BO_ManualReleaseBatchReports

FR_CarrierFreightDescriptions

FR_Carriers

FR_CarrierServices

SO_BatchPrintFilters

SO_BatchPrintSettings

SO_BatchProcessTypes

SO_BORun

SO_BORunLines

SO_CashSale

SO_CreditNoteInvoiceLink

SO_CreditReasons

SO_CustomSettings

SO_CustomSettingValues

SO_Documents

SO_EDIMain

SO_EmailLog

SO_ExportLines

SO_ExportMain

SO_ForwardOrderProcessBatch

SO_ForwardOrderProcessBatchLines

SO_ForwardOrderScheduleBatch

SO_ForwardOrderScheduleBatchLines

SO_FoundStockAudit

SO_FoundStockAuditLines

SO_History

SO_HistoryCarrier

SO_HistoryCustomSetting

SO_HistoryFreightItems

SO_HistoryCustomSettingValues

SO_HistoryPayments

SO_Incidents

SO_IncidentTypes

SO_LineCustomFields

SO_LineCustomValues

SO_LineDetails

SO_LineExtra

SO_Lines

SO_LineSerials

SO_LineShippingLabels

SO_Main

SO_Notes

SO_PaymentDetails

SO_Payments

SO_PaymentTypes

SO_PrintLog

SO_Run

SO_SalesDelBatch

SO_SalesDelBatchLines

SO_SalesHistory

SO_SplitOrders

Scheduled Scripts

SS_Credentials

SS_History

SS_Main

SS_Schedules

SS_Scripts

Service Manager

SM_Billing

SM_CashSale

SM_CustomerReturnLineDetails

SM_CustomerReturns

SM_Department

SM_EmailLog

SM_Job

SM_JobEquipment

SM_JobLabour

SM_JobNotes

SM_JobParts

SM_LabourLineCustomFields

SM_LabourLineCustomValues

SM_LabourLineDetail

SM_PartLineDetails

SM_Priority

SM_Qualification

SM_Service

SM_Skill

SM_Staff

SM_StaffRating

SM_Status

SM_SubCategory

SM_SupportPack

SM_TaskCustomSettings

SM_TaskCustomSettingValues

SM_TaskDocuments

Supplier Returns

RA_CreditLineDetails

RA_CreditLines

RA_CreditMain

RA_Documents

RA_Notes

RA_RequestIn

RA_ReturnCodes

RA_SelectedShipLines

RA_ShipIn

RA_ShipLineDetails

RA_ShipLines

RA_ShipMain

System

EM_Attachments

EM_Main

EM_TemplateAttachments

EM_Templates

RP_LabelNo

RP_PurchaseSchedule

IM_ImportQueue

SY_Branch

SY_BreakOutScripts

SY_ClusterServers

SY_Counters

SY_DesktopShortcuts

SY_DocumentLinks

SY_DocumentTypes

SY_ExportReports

SY_File

SY_FilterDefaults

SY_Filters

SY_FiltersTemp

SY_FormAccessControlObjects

SY_Forms

SY_FormSectionLinks

SY_FormSections

SY_MessageLinks

SY_NoteTypes

SY_NotificationMessages

SY_Numbers

SY_PeriodRollover

SY_Pluglet

SY_PlugletDeploymentScripts

SY_PlugletSupportFiles

SY_SavedReportRanges

SY_SearchColumns

SY_SearchFilters

SY_SearchQueries

SY_SearchTypes

SY_SearchUserSettings

SY_SearchUserSettingValues

SY_StoredProcedures

SY_Switches

SY_SwitchSectionLinks

SY_SwitchSections

SY_SysHistory

SY_SysValues

SY_SysValuesLog

SY_UpgradeLog

SY_UserProfile

SYS_Process

Tax

TX_Main

ToDo

TD_Collaborations

TD_Comments

TD_Dependencies

TD_LogicalStatuses

TD_Main

TD_TodoTypes